Generating Virtual Preview of Targets

When you create a mapping specification, source column values undergo modifications based on the applied transformations. These modified values are updated in target columns based on the target update strategy. You can generate a virtual preview of targets to view the updated target columns.

Mapping specifications involving multiple source or target systems do not support virtual preview of targets.

To generate a virtual preview of targets, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click a map.

    3. The Mapping Specification grid appears.

    Previewing Mapping Specification
  3. Click Icon Previewing Map.

    4. Mapping Preview page appears, displaying the virtual preview of the target based on the source and transformations.

    Mapping preview is currently supported for RDBMS only. Here is the list of transformation supported in Mapping Preview:

    CONCAT, LTRIM, RTRIM, TRIM, CEIL, FLOOR, RPAD, LPAD, ROUND, SQRT, SUBSTR, UPPER, LOWER, TRUNC, SIN, COS, TAN, SINH, TANH, REVERSE, IS_DATE, IS_NUMBER, IS_SPACES, ISNULL, IIF, ISEMPTY, NVL, DECODE.

    Preview Map Page

    You can download the mapping preview details in the XLSX format. To download the mapping preview details, click Icon Export Excel .